CREATE TABLE [dbo].[FullAddress]
(
[FullAddressKey] [uniqueidentifier] NOT NULL,
[ContactKey] [uniqueidentifier] NOT NULL,
[SalutationKey] [uniqueidentifier] NULL,
[PhysicalAddressKey] [uniqueidentifier] NULL,
[DaytimePhoneAddressKey] [uniqueidentifier] NULL,
[EveningPhoneAddressKey] [uniqueidentifier] NULL,
[FaxAddressKey] [uniqueidentifier] NULL,
[EmailAddressKey] [uniqueidentifier] NULL,
[AdditionalLine1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdditionalLine2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FullAddressDesc] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AddressPurposeKey] [uniqueidentifier] NULL,
[AddresseeText] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsAddresseeOverridden] [bit] NOT NULL CONSTRAINT [DF_FullAddress_IsAddresseeOverridden] DEFAULT ((0)),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [PK_FullAddress] PRIMARY KEY CLUSTERED ([FullAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_ContactKey] ON [dbo].[FullAddress] ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_DaytimePhoneAddressKey] ON [dbo].[FullAddress] ([DaytimePhoneAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_EmailAddressKey] ON [dbo].[FullAddress] ([EmailAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_EveningPhoneAddressKey] ON [dbo].[FullAddress] ([EveningPhoneAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_FaxAddressKey] ON [dbo].[FullAddress] ([FaxAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_PhysicalAddressKey] ON [dbo].[FullAddress] ([PhysicalAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_FullAddress_SalutationKey] ON [dbo].[FullAddress] ([SalutationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressMain_DaytimePhone] FOREIGN KEY ([DaytimePhoneAddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressMain_Email] FOREIGN KEY ([EmailAddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressMain_EveningPhone] FOREIGN KEY ([EveningPhoneAddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressMain_Fax] FOREIGN KEY ([FaxAddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressMain_Physical] FOREIGN KEY ([PhysicalAddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_AddressPurposeRef] FOREIGN KEY ([AddressPurposeKey]) REFERENCES [dbo].[AddressPurposeRef] ([AddressPurposeKey])
GO
ALTER TABLE [dbo].[FullAddress] ADD CONSTRAINT [FK_FullAddress_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO